python读取excel部分值存入另一个excel-python 读取excel数据插入到另外一个excel

#-*-coding:utf-8-*-

import xlrd

import xlwt

def excel_copy(dir_from, dir_to, sheet_name):

'''从一个excel写入到另外一个excel'''

wb = xlrd.open_workbook(dir_from)

# 选择sheet页

sheet1 = wb.sheet_by_index(0)

# 打印每个sheet页的行数

# print("sheet1行数：%d" % sheet1.nrows)

# 创建写入文件

workbook = xlwt.Workbook(encoding="ascii")

# 创建写入sheet页

worksheet = workbook.add_sheet(sheet_name)

# 写入excel

for i in range(0, sheet1.nrows):

values_row1 = sheet1.row_values(i)

print(values_row1)

for s in range(len(values_row1)):

worksheet.write(i, s, values_row1[s])

workbook.save(dir_to)

python 读取SQLServer数据插入到MongoDB数据库中

# -*- coding: utf-8 -*-import pyodbcimport osimport csvimport pymongofrom pymongo import ASCENDING, ...

Windows下Python读取GRIB数据

之前写了一篇<基于Python的GRIB数据可视